<?php
require("includes/basic.php");
$gettask=mysql_query("select * from task_assigned_to a, task_master t, task_status s, project_master p,  phase_master sm,  module_master m where a.task_id=t.task_id and a.task_assigned_to=5 and s.task_id=t.task_id and s.task_status=1 and p.project_id=a.project_id and a.phase_id=sm.phase_id and a.module_id=m.module_id");
$taskno = mysql_num_rows($gettask);
$i=0;
while($taskr=mysql_fetch_array($gettask))
{
	/*$project=mysql_query("select * from project_master where project_id=".$taskr['project_id']);	
	while($prores= mysql_fetch_array($project);)
	{*/
		$proid=$taskr['project_id'];
		$projname=$taskr['project_name'];
	/*}
	$phase=mysql_query("select * from phase_master where phase_id=".$taskr['phase_id']);
	while($phaseres=mysql_fetch_array($phase))
	{*/
		$sid=$taskr['phase_id'];
		$phasename=$taskr['phase'];
	/*}
	$module=mysql_query("select * from module_master where module_id=".$taskr['module_id']);
	while($modres=mysql_fetch_array($module))
	{*/
		$mid=$taskr['module_id'];
		$modname=$taskr['module'];
		$tid=$taskr['task_id'];
	//}
	$tasks[$i]=$proid."=>".$projname."-xendprox-".$sid."=".$phasename."-xendphasex-".$mid."-".$modname."-xendmodx-".$tid.":".$taskr['task_title']."-xendx-";
	$i++;
}
foreach($tasks as $a => $b)
{
	echo $b;
}
?>